SELECT dem.provider_no AS Provider, demph.demographic_no AS DemNo, demph.pharmacyID AS PharID, ph.name AS Pharmacy, ph.address AS PharmacyAddr,
dem.last_name AS PatLName, dem.first_name AS PatFName
FROM demographicPharmacy demph
LEFT JOIN demographic dem ON demph.demographic_no = dem.demographic_no
LEFT JOIN pharmacyInfo ph ON demph.pharmacyID = ph.recordID
WHERE demph.status = 1
AND dem.provider_no = '{provider}'
ORDER BY dem.provider_no, demph.pharmacyID, dem.last_name
select distinct provider_no, concat(last_name,',',first_name,'(',provider_no,')')
from provider
where provider_type = 'doctor'
order by last_name ;